The Revaluation Tool
In order to perform a revaluation a user must have global edit privileges in the CatalogdaReplace
) and be able to perform a replace on all the fields to be updated (column access of duReplace
). The default columns that require replace permission are:
- ValValuedByRef
- ValDateValued
- ValReasonForValuation
- ValValuationAmount
- ValValuationNotes
Updating valuation information in EMu can be tedious if a large batch of records needs to be changed. The EMu Global Replace facility may be used to apply a set of values for a series of records, making the batch update of records easier; however in most instances a global replace does not provide sufficient control to update the valuation amount correctly. For example, you may want to increase the current valuation by 5%. The global replace facility does not provide a mechanism that allows field values to be computed.
The Revaluation tool enables users to update valuation information for either a single record or a group of records. The tool is very similar to the Relocation tool used to update location information.
The Revaluation tool is found by selecting Tools>Revalue from the Catalog
The Revaluation tool provides three different methods for calculating the new amount:
- Set Amount
Allows an absolute value to be set. The value entered into the input box to the right of the option is set for all objects to be revalued.
- Add Fixed Amount
Adds a fixed amount to the existing valuation. The current value of each object is read and a fixed amount is added to it. A negative value may be used to decrease the valuation. If an object does not contain a current valuation, the value is left empty.
- Add Percentage
Adds a fixed percentage to the current valuation. The current value of each object is determined and then increased by a fixed percentage. Using this option it is possible to add 5% to the selected objects. A negative percentage may be used to devalue objects. If an object does not contain a current valuation, the value is left empty.
After the value has been calculated the tool can also round the result up to the nearest specified amount. For example, entering a value of 10.00 would result in all valuations being rounded up to the nearest ten dollars.
The Revaluation tool is found by selecting Tools>Revalue from the Catalog
The Date Valued field is filled with the current date. Other values entered are remembered the next time the tool is used in the current form (Date Valued is always updated).
When the Update button is clicked the revaluation begins. The Updating box will display with an indication of how many records have been processed:
When the process is complete the dialog
If a record cannot be updated because it is being edited by another user, a message will display requesting what action to take:
Note: While the tool provides a useful facility for upgrading batches of records, the standard valuation mechanism of entering data for a single record is still supported.